/****** Object: Table [dbo].[Basket]   Script Date: 06.07.2011 14:26:14 ******/
USE [SoftServeProject];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [dbo].[Basket] (
[id_basket] int IDENTITY(1, 1) NOT NULL,
[id_product] int NOT NULL,
[id_user] int NOT NULL,
[status] bit NOT NULL,
[count] int NOT NULL,
CONSTRAINT [PK__Basket__023D5A04]
PRIMARY KEY NONCLUSTERED ([id_basket] ASC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON )
 ON [PRIMARY],
CONSTRAINT [FK__Basket__id_produ__3C69FB99]
FOREIGN KEY ([id_product])
REFERENCES [dbo].[Product] ( [id_product] ),
CONSTRAINT [FK__Basket__id_user__3D5E1FD2]
FOREIGN KEY ([id_user])
REFERENCES [dbo].[Users] ( [id_user] )
)
ON [PRIMARY];
GO




